home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
dbase
/
videomgt.zip
/
DEL.PRG
< prev
next >
Wrap
Text File
|
1991-11-23
|
1KB
|
61 lines
&& DELETE RECORDS ===> DEL.PRG
SET TALK OFF
USE YSALES
INDEX ON CUST_NO + FILM_NO TAG CFILM
SET ORDER TO CFILM
DO WHILE .T.
MX=" "
MANS=" "
MMC=SPACE(4)
MMF=SPACE(4)
MT=SPACE(1)
MCUST_NO1=SPACE(4)
MDATE1=CTOD(SPACE(8))
MFILM_NO1=SPACE(4)
MRETURNED1=.F.
@ 10,12 SAY "ENTER THE CUSTOMER NUMBER TO DELETE " GET MMC
@ 12,12 SAY "ENTER THE FILM NUMBER TO DELETE " GET MMF
READ
GOTO TOP
SEEK MMC + MMF
IF FOUND ()
CLEAR
DO WHILE CUST_NO = MMC .AND. FILM_NO = MMF
@ 6,6
DISP CUST_NO, DATE, FILM_NO, RETURNED
EXIT
ENDDO
@ 16,12 SAY " DO YOU REALLY WANT TO DELETE(Y/N)? " GET MT
READ
IF MT $"Yy"
DNOS=DNOS+1
DELETE
ENDIF
ELSE
@ 16,12 SAY "THIS RECORD IS NOT FOUND, PLEASE CHECK THE NUMBERS ENTERED"
@ 18,12 SAY "DO YOU WANT TO CONTINUE(Y/N)? " GET MX
READ
IF MX $"Nn"
EXIT
ELSE
CLEAR
LOOP
ENDIF
ENDIF
CLEAR
@ 12,19
WAIT " DO YOU WANT TO CONTINUE(Y/N)? " TO MANS
IF MANS $"Yy"
CLEAR
LOOP
ELSE
EXIT
ENDIF
ENDDO
CLEAR
@ 10,36 SAY "W A I T"
PACK
ERASE CFILM.MDX
USE
RETURN